package com.example.demo.mapper;

import com.example.demo.model.Message;
import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;

@Mapper
public interface MessageMapper {
    @Insert("insert into message_info (`from`, `to`, `message`) values (#{from}, #{to}, #{message})")
    Integer publishMessage(Message message);

    @Select("select `id`, `from`, `to`, `message`, `delete_flag`, `create_time`, `update_time` " +
            "from message_info where `delete_flag` = 0")
    List<Message> getMessageList();
}
